﻿/*
	Version 0.0.2
	Start Date		: 15.11.2013
	Release Date	: 
	
	Db Patches 

	ALTER TABLE `categories`
	ADD UNIQUE INDEX `Name` (`Name`);

	ALTER TABLE `categories`
	ADD COLUMN `Is_Hot` SMALLINT NOT NULL DEFAULT '0' AFTER `Name`;

	CREATE TABLE `settings` (
	`Id` INT(10) NOT NULL,
	`Art_Cnt_Per_Cat_On_Home` INT(10) NOT NULL DEFAULT '3',
	PRIMARY KEY (`Id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB;

ALTER TABLE `articles`
	ADD COLUMN `Created` DATETIME NOT NULL AFTER `Likes`,
	ADD COLUMN `Edited` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP AFTER `Created`;

	ALTER TABLE `articles`
	ADD COLUMN `Is_Draft` INT(10) NOT NULL DEFAULT '1' AFTER `Edited`;
*/